CREATE PROCEDURE [dbo].[sp_sec_AddResourcePermission]
@FKResource int, @FKPermission int, @UserUpdater int
AS
BEGIN
  BEGIN TRAN A
  INSERT INTO SC_ResourcePermission(FKResource,FKPermission,UpdatedBy)
  VALUES(@FKResource ,@FKPermission , @UserUpdater );
  IF @@ERROR<>0 BEGIN
    ROLLBACK TRAN A
  END
  COMMIT TRAN A
END